SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



ALTER    view v_td_filbaltype
as
select ft.*, f.fi_filnm as ffilnm, f2.fi_filnm as corrfilnm from td_filbaltype ft
left join td_filiale f on f.fi_filid = ft.ffilid
left join td_filiale f2 on f2.fi_filid = ft.corrfilid



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

